﻿<?xml version="1.0" encoding="utf-8"?>
<queries>
  <query key="CreateAcquaintanceFormReportTable">
    <mssql><![CDATA[create table {0}
  ([ReportSessionId] varchar(256) NOT NULL,
   [RowNumber] int,
   [ShortName] nvarchar(max),
   [LastName] nvarchar(max),
   [JobTitle] nvarchar(max),
   [Department] nvarchar(max))]]></mssql>
    <postgres><![CDATA[create table {0}
(ReportSessionId citext NOT NULL,
  RowNumber int,
  ShortName citext,
  LastName citext,
  JobTitle citext,
  Department citext)]]></postgres>
  </query>
  <query key="SelectDataFromTable">
    <default><![CDATA[select *
from  Sungero_Reports_AcquaintanceForm temp
where ReportSessionId = @ReportSessionId]]></default>
  </query>
</queries>